---
title: DB-CLL-039 — Delete a legal file location record
summary: Delete a legal file location record
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-039 — Delete a legal file location record

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-039 |
| Operation type | D |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsLegalFileLocation |
| Criteria property | DeleteSQL |
| Lifecycle method | BeforeDelete |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalFileLocationID | Input | NUMBER | N/A | File-location identifier to delete |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_FILE_LOCATION](../database-tables.md#legal_file_location) | DELETE | LegalFileLocationID |

## Sample SQL

```sql
Delete From LEGAL_FILE_LOCATION
Where
  LEGAL_FILE_LOCATION.LEGAL_FILE_LOCATION_SEQ_NUM = :LegalFileLocationID
```

## Operations and processes

- [Manage legal file locations](../operations/manage-legal-file-location.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)
- [BR-CLM-LGL-019](../business-rules.md#br-clm-lgl-019-file-location-falls-back-to-a-sentinel-value-on-lookup-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb`